<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_users`;");
E_C("CREATE TABLE `ecs_users` (
  `user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(60) NOT NULL DEFAULT '',
  `user_name` varchar(60) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `question` varchar(255) NOT NULL DEFAULT '',
  `answer` varchar(255) NOT NULL DEFAULT '',
  `sex` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `birthday` date NOT NULL DEFAULT '0000-00-00',
  `user_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `frozen_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pay_points` int(10) unsigned NOT NULL DEFAULT '0',
  `rank_points` int(10) unsigned NOT NULL DEFAULT '0',
  `address_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `reg_time` int(10) unsigned NOT NULL DEFAULT '0',
  `last_login` int(11) unsigned NOT NULL DEFAULT '0',
  `last_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_ip` varchar(15) NOT NULL DEFAULT '',
  `visit_count` smallint(5) unsigned NOT NULL DEFAULT '0',
  `user_rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `is_special` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ec_salt` varchar(10) DEFAULT NULL,
  `salt` varchar(10) NOT NULL DEFAULT '0',
  `parent_id` mediumint(9) NOT NULL DEFAULT '0',
  `flag` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `alias` varchar(60) NOT NULL,
  `msn` varchar(60) NOT NULL,
  `qq` varchar(20) NOT NULL,
  `office_phone` varchar(20) NOT NULL,
  `home_phone` varchar(20) NOT NULL,
  `mobile_phone` varchar(20) NOT NULL,
  `is_validated` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `credit_line` decimal(10,2) unsigned NOT NULL,
  `passwd_question` varchar(50) DEFAULT NULL,
  `passwd_answer` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  KEY `email` (`email`),
  KEY `parent_id` (`parent_id`),
  KEY `flag` (`flag`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_users` values('1','ecshop@ecshop.com','ecshop','554fcae493e564ee0dc75bdf2ebf94ca','','','0','1960-03-03','0.00','0.00','98388','15390','1','0','1245048540','0000-00-00 00:00:00','0.0.0.0','11','0','0','','0','0','0','','','','','','','0','0.00','','');");
E_D("replace into `ecs_users` values('2','vip@ecshop.com','vip','232059cb5361a9336ccf1b8c2ba7657a','','','0','1949-01-01','0.00','0.00','0','0','0','0','0','0000-00-00 00:00:00','','0','0','0','','0','0','0','','','','','','','0','0.00','','');");
E_D("replace into `ecs_users` values('3','text@ecshop.com','text','1cb251ec0d568de6a929b520c4aed8d1','','','0','1949-01-01','0.00','0.00','0','0','2','0','1242973574','0000-00-00 00:00:00','0.0.0.0','2','0','0','','0','0','0','','','','','','','0','0.00','','');");
E_D("replace into `ecs_users` values('5','zuanshi@ecshop.com','zuanshi','815a71fb334412e7ba4595741c5a111d','','','0','1949-01-01','0.00','10000.00','0','0','0','0','0','0000-00-00 00:00:00','','0','3','0','','0','0','0','','','','','','','0','0.00','','');");
E_D("replace into `ecs_users` values('6','TEST@DII.COM','TEST','0103b969be5a289e2628fe7c4d01fbd8','','','0','0000-00-00','0.00','0.00','0','0','0','1374890996','1374890996','0000-00-00 00:00:00','116.237.74.35','1','0','0','','0','0','0','','TEST@hotmail.com','2222222','222222222222','22222222','222222222222','0','0.00','friend_birthday','1111');");
E_D("replace into `ecs_users` values('7','why123@qq.com','why118','ef623de0437ba8d89b6f3d2fe9b8ae35','','','0','0000-00-00','0.00','0.00','0','0','3','1375637777','1375637777','0000-00-00 00:00:00','27.24.159.18','1','0','0','','0','0','0','','','','','','','0','0.00','','');");
E_D("replace into `ecs_users` values('8','51063735@QQ.COM','thtc01','4297f44b13955235245b2497399d7a93','','','0','0000-00-00','0.00','0.00','0','0','0','1376380755','1376380755','0000-00-00 00:00:00','125.110.61.147','1','0','0','','0','0','0','','51063735@qq.com','51063735','13676733672','13676733672','13676733672','0','0.00','friend_birthday','123');");
E_D("replace into `ecs_users` values('9','6868681@qq.com','yyehome','95119c32799d3371f044e7fd49e54001','','','0','0000-00-00','0.00','0.00','0','0','0','1377136260','1377136260','0000-00-00 00:00:00','222.241.124.170','1','0','0','','0','0','0','','6868681@msn.com','6868681','13973707193','13973707193','13973707193','0','0.00','old_address','益阳');");
E_D("replace into `ecs_users` values('10','5451943@qq.com','tacy','98bfdd4da6ac5073a8e7849d6a660de8','','','0','0000-00-00','0.00','0.00','0','0','4','1377398930','1377398930','0000-00-00 00:00:00','222.216.204.68','1','0','0','','0','0','0','','','','','','','0','0.00','','');");
E_D("replace into `ecs_users` values('11','47637@qq.com','test01','6ea59424cbec53d355ac273c8d915a33','','','0','0000-00-00','0.00','0.00','0','0','0','1377716378','1377823050','0000-00-00 00:00:00','59.42.174.44','3','0','0','4887','0','0','0','','47637@qq.com','47637','1234567','1234567','13800138000','0','0.00','old_address','中国');");
E_D("replace into `ecs_users` values('12','47849723@163.com','clmwan','038868c5d7c9f7dddf789aa361e88ccb','','','0','0000-00-00','0.00','0.00','0','0','0','1377758924','1377758992','0000-00-00 00:00:00','221.204.169.91','3','0','0','7144','0','0','0','','47849723@163.com','1789127','5646546','2316546','13858885888','0','0.00','old_address','123123');");
E_D("replace into `ecs_users` values('13','hsdjfh@163.com','qqq','7417d37a765584d4def82783ffda60f9','','','0','0000-00-00','0.00','0.00','0','0','5','1377988150','1377988271','0000-00-00 00:00:00','42.184.67.218','2','0','0','737','0','0','0','','','','','','','0','0.00','','');");

require("../../inc/footer.php");
?>